If you took the sleeping pill in your dream, it means that you are unable to relax. There is also a possibility that you are very stressed out because of some situation.
Dream dictionary: Sleeping pills dream meanings
Dreaming of narcotics, sedatives or sleep remedies, whether youre the one taking them in your dream or they simply appear in it, indicates that youre trying to escape from reality and the responsibilities you have to face and solve in the future. No matter how much you ignore them, theyre not going to disappear.